README.TXT for Database Table Reporter (DTR) version 1.04 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ------------------------------------------------------------------------------ Database Table Reporter is Copyright (c) 1993 by VS Toolbox Software - All Rights Reserved - Welcome to the land of FREEWARE! This Paradox for Windows (PfW) program is brought to you FREE, but ONLY for your PERSONAL, not-for-profit use. You may NOT build upon this program or remove major sections of code and then re-sell it in any way, shape or form. ------------------------------------------------------------------------------ The Database Table Reporter started out as an "afternoon project" in March and has grown into it's current state. And I thought PfW and OPAL would be simple since, I've had many years of experience working with Paradox DOS and PAL! Even though it's hard at first, it can sure be lots of fun. Not only will this program offer you some REAL value, in providing you with useful Table documentation, but it encapsulates many hours of my personal trial-and-error techniques to find out what works and what doesn't. Along with several hundred dollars invested in on-line PdoxWin forum messaging with the very helpful Borland Technical Support personnel and other forum members. My hat is off to all who have trodden the OPAL path before me!! I just hope they keep sharing their knowledge, as they are able to, just as I am doing via this program. ****************************************************************************** * If you like DTR I would be very pleased to receive a "donation" from you, * * which will be used to offset my "research" expenses (CI$ bill). * * Please send to: * * * * Don Goyette * * VS Toolbox Software * * 3908 Midsummer Lane North * * Colorado Springs, CO 80917-3506 * ****************************************************************************** If you find any nasty little "bugs", OR, if you code a great new report that you would like to see included in a future version of DTR, please leave me a note on CompuServe at ID# 71601,3624. In conclusion, I certainly hope you find DTR to be not only a useful program, but educational as well! Enjoy... Sincerely, Don Goyette P.S. Future versions of DTR will contain many more reports and functions, as my patience, time and funds allow. When new versions are uploaded to the forum library, they will automatically replace previous versions, so keep an eye on the version # in the file description field of the library entry. INSTALLATION AND STARTUP ~~~~~~~~~~~~~~~~~~~~~~~~ Simply unzip this file (DTR.ZIP), using PKUNZIP, into a directory of it's own (Paradox likes that) OR into your Paradox for Windows "utility program" directory ONLY if you are sure there won't be a conflict with the any of the filenames listed below. 1. Run Paradox for Windows, 2. Change your Working Directory to the one you unzipped DTR into, and 3. Open any DTR Form (the program will always start at the main Form, regardless of which Form you initially select). The main start-up form displays simple instructions for using DTR and the on-line Help/Information window provides even more info. 4. To exit the program, simply select File/Exit from the menu bar. ------------------------------------------------------------------------------ ZIP file contents of DTR.ZIP ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Database Tables and related files: REPORTS.DB.........Contains the names of built-in reports. REPORTS.VAL........Value checks for the REPORTS table. REPORTS.PX.........Primary Index file for the REPORTS table. UN-Delivered Forms: ABOUT.FSL..........The pop-up "About" dialog box. HELP.FSL...........The pop-up "Help" window. TBLRPTS.FSL........The main Database Table Reporter form. UN-Delivered Reports: FIELDLST.RSL.......The FieldLst "report". PrintString (PrtStr) files: PRTSTR.DLL.........Shareware version of our PrintString Windows DLL. REGISTER.TXT.......Registration form for the PrtStr DLL. Other files: DTRLIB.LSL.........UN-Delivered ObjectPAL library routines for DTR. README.TXT.........This file. VERSION HISTORY AND NOTES ~~~~~~~~~~~~~~~~~~~~~~~~~ 1.05 - Release Date: 6/2/93 ~~~~~~~~~~~~~~~~~~~~~~~~~~~ * Fixed problem that wouldn't allow access of table via a directory path which were outside of the WORKing directory. 1.04 - Release Date: 5/10/93 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ * Modified the FieldLst report to include Referential Integrity Information. * Created a Windows DLL in order to allow this application (and other PfW apps) to print text directly to the default Windows printer. The file is named PRTSTR.DLL and is a Shareware version. * Replaced the FieldLst report's Secondary Index Info table frame with an ObjectPAL controlled printout to properly list the subordinate fields to each Secondary Index. * Modified the FieldLst report to include DOS File Statistics, which includes DOS filename, size, date & time of last modification and total size for all DOS files related to the 'base' table (.DB, .MB, .PX, .Xnn, .Ynn, .XGn and .YGn file extensions). * Moved the encrypted table password entry code into a Library, which can be used by other applications. The new library file is DTRLIB.LSL. 1.03 - Release Date: 4/17/93 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ * Fixed a multi-table selection bug - would re-print the first table Fields. This was only a problem in version 1.02 (with Secondary Index Info). * Added check for .DBF files, since DTR doesn't handle them yet and the user can override the PfW Browser default selections. * Added "Password Protected?" field to Field List report. * Changed the way the current Table Name is passed to the report and removed all old code (multi-stage process to print report). It's now passed via a table built on-the-fly (RPTVARS.DB), which also allows for future expansion. Now the report doesn't need to be loaded in "design" mode and messing up the screen! * Centered the Secondary Index Info section on the Field List report. * Added a default value to the Report listbox of the main screen. 1.02 - Release Date: 4/14/93 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ * Fixed the PfW array errors by making it a "resizable" array. * Main form is now Maximized (most of the time). * Moved the Print Report|pushButton code to the Form's Proc area. * Modified the Print Report|pushButton method to call an appropriate Proc. * Modified the FIELDLST report to include Secondary Index Info. * General clean-up of several method's code sections. * Added more "status messages" to the table creation and report code. * New library filename per sysop (DTR.ZIP) without a version #. 1.01 - Release Date: 4/10/93 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ * First CIS PdoxWin library upload. (Released with known array error.)